home *** CD-ROM | disk | FTP | other *** search
/ MacWorld 2003 May (DVD) / Macworld Resource DVD May 2003.toast / Data / Software / Bonus / Database / mysql-max-3.23.55.sit / mysql-max-3.23.55-apple-darwi.1 / mysql-test / t / rpl000010.test < prev    next >
Encoding:
Text File  |  2003-01-21  |  519 b   |  21 lines  |  [TEXT/ttxt]
  1. #this tests the offset off by 22 mystery bug
  2. #must run slave with --disconnect-slave-event-count=1 --master-connect-retry=1
  3. source include/master-slave.inc;
  4. connection slave;
  5. drop table if exists t1;
  6. connection master;
  7. drop table if exists t1;
  8. create table t1 (n int not null auto_increment primary key);
  9. insert into t1 values(NULL);
  10. insert into t1 values(2);
  11. save_master_pos;
  12. connection slave;
  13. sync_with_master;
  14. select n from t1;
  15. connection master;
  16. drop table t1;
  17. save_master_pos;
  18. connection slave;
  19. sync_with_master;
  20.  
  21.